﻿CREATE TABLE [Files](
--附件信息
	[FilesID] [int] IDENTITY(1,1) NOT NULL CONSTRAINT PK_Files PRIMARY KEY (FilesID),
	[Name] [nvarchar](10) NULL,
	[Path] [varchar](100) NOT NULL,
	[AddTime] [datetime] NOT NULL default(getdate()),
	[Depict] [ntext] NULL
)
GO

CREATE TABLE [Users](
--用户信息
	[LoginID] [varchar](20) NOT NULL CONSTRAINT PK_Users PRIMARY KEY (LoginID),
	[Name] [nvarchar](10) NULL,
	[Pwd] [varchar](100) NOT NULL,
	[Depict] [ntext] NULL
)
GO

insert into Users (LoginID, Name, Pwd, Depict)
values('admin', 'admin','123456', '系统管理')
insert into Users (LoginID, Name, Pwd)
values('admin-1', 'admin','123456')
insert into Users (LoginID, Name, Pwd)
values('admin-2', 'admin','123456')
insert into Users (LoginID, Name, Pwd)
values('admin-3', 'admin','123456')
insert into Users (LoginID, Name, Pwd)
values('admin-4', 'admin','123456')
insert into Users (LoginID, Name, Pwd)
values('admin-5', 'admin','123456')
insert into Users (LoginID, Name, Pwd)
values('admin-6', 'admin','123456')
insert into Users (LoginID, Name, Pwd)
values('admin-7', 'admin','123456')
insert into Users (LoginID, Name, Pwd)
values('guest', 'guest','123456')
insert into Users (LoginID, Name, Pwd)
values('test', 'test','123456')


CREATE TABLE TB_Personal
(--个人信息表
	ID int NOT NULL IDENTITY (1, 1) CONSTRAINT PK_TB_Personal PRIMARY KEY (ID),
	Name nvarchar(10) NOT NULL,
	Birthday datetime NOT NULL DEFAULT ('1999-03-01'),
	Sex int NOT NULL,
	Nation nvarchar(20) NULL,
	Mobile varchar(20) NULL,
	Email nvarchar(100) NULL,
	Address ntext NULL,
	Photo varchar(100) NULL,
	Interest nvarchar(100) NULL
)